18,162 questions with SQL Server-related tags

Sort by: Updated
0 answers

Managed Instance - Weekly report of logins

What's the best way to get a weekly report from an Azure Managed Instance giving all logon information (User, date, IP, success, etc)? I want all SQL logins and Entra ID logins. I've followed the steps detailed here:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-28T19:29:46.55+00:00
HSB 25 Reputation points
0 answers

Debugging SQL Server on Linux from remote VS 2022 pc

Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
953 questions
asked 2024-05-28T18:57:39.8333333+00:00
Torsten Kiltz 0 Reputation points
3 answers

Cannot add drive using Failover Cluster Manager - no disks suitable for cluster disks were found

I am creating a new SQL cluster to replace out old cluster. I created a new, two server cluster running Server 2022. I am told I need to add the disk to the cluster before I can install our SQL server software. I created a new volume in our PowerStore.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,307 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
637 questions
asked 2024-02-20T16:28:13.2166667+00:00
Doug V 0 Reputation points
answered 2024-05-28T18:06:44.8666667+00:00
Manojkumar Ganesamoorthy 0 Reputation points Microsoft Employee
0 answers

My listview is listing only the id instead of 3 items on the table

PLEASE HELP ME I am working on sqlite database , i have the following code in c# maui return (await conn.Table<ServiceData>().ToListAsync()) ```.Where(s…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
704 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
2,989 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,401 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
4 questions
asked 2024-05-28T15:40:05.35+00:00
Gbenga Banuso Odumosu 40 Reputation points
edited the question 2024-05-28T17:36:38.2033333+00:00
Richard Hay 1,246 Reputation points Microsoft Employee
0 answers

Path to Microsoft ODBC SSL Driver loaded libraries

How do configure dynamic loading of OpenSSL libraries for use MS ODBC? The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system. Our software is linked custom…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
asked 2024-05-28T17:09:47.63+00:00
Denis Kupavtsev 0 Reputation points
3 answers

The MSSQLSERVER and AGENT service terminated unexpectedly

Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,544 questions
asked 2024-05-27T20:33:02.6366667+00:00
Yohany Sanchez 0 Reputation points
commented 2024-05-28T14:21:00.58+00:00
Yohany Sanchez 0 Reputation points
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,546 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,661 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan 25 Reputation points
1 answer One of the answers was accepted by the question author.

Reporting Services logs and database tables

hi all, Do the RS logs and various log database tables contain the same information? I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,827 questions
asked 2024-05-27T12:41:11.9033333+00:00
elsvieta 346 Reputation points
commented 2024-05-28T12:49:28.1033333+00:00
elsvieta 346 Reputation points
4 answers

How to connect my c# application to my phpmyadmin database from my NAS?

Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,401 questions
asked 2024-05-26T11:07:34.2566667+00:00
BgnerNprg207 226 Reputation points
answered 2024-05-28T11:24:12.5333333+00:00
BgnerNprg207 226 Reputation points
2 answers

SSRS Report Subscription Windows Share File Option Failed

We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,827 questions
asked 2024-05-24T14:47:14.9633333+00:00
Vinaya Velli 0 Reputation points
commented 2024-05-28T10:17:12.3+00:00
Vinaya Velli 0 Reputation points
1 answer

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-24T00:46:20.3866667+00:00
Michael F. Assis 5 Reputation points
commented 2024-05-28T10:01:30.78+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Dataset format needed for azure blob storage

How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,492 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,774 questions
asked 2024-05-24T13:53:47.7833333+00:00
Reema DSouza 0 Reputation points
accepted 2024-05-28T09:55:59.89+00:00
Reema DSouza 0 Reputation points
3 answers One of the answers was accepted by the question author.

Polybase s3 not working on SQL Server 2022 Linux

Trying to connect to parquet files on S3 from SQL server 2022 Linux fails with the following error: CREATE EXTERNAL DATA SOURCE myds WITH ( LOCATION = 's3://mybucket' , CREDENTIAL = mycreds ); GO 111631;The specified…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2022-06-06T18:53:24.237+00:00
Daniel Hartl 21 Reputation points
commented 2024-05-28T09:46:29.1333333+00:00
Maxpia 1 Reputation point
3 answers

Windows 11 Microsoft SQL 2022 Express Edition

Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,455 questions
asked 2024-05-27T12:19:53.0033333+00:00
Richard Uhrin 0 Reputation points
accepted 2024-05-28T09:43:20.91+00:00
Richard Uhrin 0 Reputation points
2 answers One of the answers was accepted by the question author.

bit null ,0

Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,564 questions
asked 2024-05-27T16:52:36.8833333+00:00
Vineet S 205 Reputation points
accepted 2024-05-28T09:36:31.5433333+00:00
Vineet S 205 Reputation points
2 answers

Transfer roles and permissions

Hi, By using sp_help_revlogin, we can transfer the logins and passwords to the secondary replica. How to transfer roles and permissions?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-27T13:17:28.1966667+00:00
Chaitanya Kiran 716 Reputation points
answered 2024-05-28T09:31:52.3433333+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
1 answer

Transfer documents from sqlserver in varbinary to Azure Blob storage

I am looking to move a large set of documents from a Managed Instance of SQL Server database where the documents are saved in varbinary data type on the sql server table. The ADF dataflow I created doesn't let me select a Azure Blob 'Binary' as the sink…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,774 questions
asked 2024-05-23T16:42:11.0466667+00:00
Reema DSouza 0 Reputation points
commented 2024-05-28T08:34:43.1433333+00:00
Reema DSouza 0 Reputation points
1 answer

How do I copy all columns properties with copy activity in data factory

Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,774 questions
asked 2024-05-26T07:29:16.98+00:00
OGINTZ Marina 85 Reputation points
commented 2024-05-28T08:15:14.5733333+00:00
ShaikMaheer-MSFT 38,206 Reputation points Microsoft Employee
0 answers

Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working

According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,307 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,582 questions
asked 2024-05-28T06:44:01.8033333+00:00
Stefanos Papaefthimiou 0 Reputation points
1 answer

Availability Groups in depth

Hi, I want in depth information on Availability Groups. Any link that I can read?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-28T04:30:49.72+00:00
Chaitanya Kiran 716 Reputation points
commented 2024-05-28T06:10:25.6066667+00:00
Chaitanya Kiran 716 Reputation points